# Install PSQL

brew install postgresql

check the psql with postgres -V

now you have a psql cli installed, which means you can connect to other psql database.

# Basic Commands

# connect to server

psql -h host -U username -d dbName

e.g. psql postgres -> connect locol db e.g. psql -h localhost -U ethanzhang -> connect to local db e.g. psql -h RDS_endpoint -U skyrocket -> connect to RDS

# General Comands

# Create DB

psql -h localhost -U ethanzhangethanzhang=# CREATE DATABASE newdatabase;ethanzhang=# \listethanzhang=# \q

# Alter DB

psql -h localhost -U ethanzhangethanzhang=#ALTER DATABASE newdatabase RENAME TO olddatabase;ethanzhang=# \listethanzhang=# \q

# Export DB

pg_dump is another command to dump & import db

pg_dump -U username -f path/name.sql dbname

e.g. pg_dump -h RDS -U skyrkt -f ./dump.sql producation

# Import DB

psql -h host -d dbname -U username -f dump.sql

we need a new db before importing

psql -h localhost -U ethanzhangethanzhang=# CREATE DATABASE staging;ethanzhang=# \listethanzhang=# \qpsql -h RDS -d staging -U skyrkt -f ./dump.sql